Sr. ETL Developer

About Madison Logic:

Our team is reshaping B2B marketing and having fun in the process! When joining Madison Logic, you are committing to giving 100% and always striving for more. As a truly global company, we take pride in a diverse culture free from gender, racial, and other forms of bias.

Our Vision: We empower B2B organizations globally to convert their best accounts faster

Our Values:

URGENCY Lead with Action. Prioritize Follow-up.

ACCOUNTABILITY Don't Point Fingers. Take Responsibility.

INNOVATION Think Big. Innovate.

RESPECT

INTEGRITY Act Ethically. Lead by Example.

At ML you will work with & learn from an incredible group of people who care about your success as much as they care about their own. Our team is at the heart of what we do and our success starts with you!

About the Role:

This is an Individual Contributor (non-management) position.

Responsibilities:

• Craft and optimize sophisticated Snowflake SQL queries for efficient data processing and analysis.
• Demonstrate proficiency in diagnosing and resolving query-related issues, including bug fixes and addressing ad-hoc problems.
• Design and implement queries tailored for applications and business intelligence reporting needs.
• Tackle data quality challenges head-on, developing and implementing solutions to enhance data integrity.
• Utilize data aggregation and modeling techniques to create comprehensive reports in Domo.
• Conduct in-depth data analysis to drive business performance improvements.
• Evaluate and select optimal data sources to meet specific project requirements.
• Team player but able to work independently with minimal direction.
• Performance Tuning - Review existing SQL Queries, Execution Plans, Partitions, and Index(s) to determine performance enhancements for long running queries.
• Excellent communicator and be able to produce clear and concise documentation.
• Ability to work in a team environment.
• Working independently with only high-level guidance.
• Strong sense of accountability, adaptability, flexibility and a sense of urgency.

Basic Qualifications:

• On-site working at the ML physical office, 5-days per week is required through the end of probation (6 months), transitioning to 2-day WFH post-probation.
• University degree and 5+ years of practical experience OR 7+ years of practical experience
• 5+ years’ experience with writing SQL queries, functions and procedures.
• 4+ years’ experience with cloud computing services (AWS)
• Experience working with data cleaning and standardizing process
• Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses)
• Requires strong analytical, conceptual and problem-solving abilities.
• Must have the skills necessary to understand the overall data warehouse architecture.
• Proven ability to handle multiple tasks and projects simultaneously.
• SnowPro certification is a plus

Other Characteristics:

• A collaborative team member with a demonstrated ability to build strong working relationships.
• Possesses strong interpersonal and communication skills, maintaining a high level of professionalism and integrity.
• Exhibits excellent organizational and project management capabilities.
• Thrives in fast-paced environments, demonstrating experience managing multiple responsibilities, tasks, and projects effectively.
• Maintains a positive, proactive attitude, readily taking a hands-on approach to tasks and projects.
• Team members are encouraged to work collaboratively with an emphasis on results, not on hierarchy or titles

Expected Compensation: (Dependent upon Experience)

Sr. ETL Developer: Fixed CTC: 17 LPA - 20 LPA

ETL Developer: 13 LPA - 16 LPA

Work Environment:

We offer a mix of in-office and hybrid working. Hybrid remote work arrangements are not available for all positions. Please refer to the job posting detail to determine what in-office requirements apply.

Pay Transparency/Equity:

.

We will provide more information about our perks & benefits upon request.

Our Commitment to Diversity & Inclusion:

Madison Logic is proud to be an equal opportunity employer. We are committed to equal employment opportunity regardless of sex, race, color, religion, national origin, sexual orientation, age, marital status, disability, gender identity or Veteran status.

Privacy Disclosure:

All of the information collected in this form and/or by your application by submission of your online profile is necessary and relevant to the performance of the job applied for. We will process the information provided by you in this form, your CV (including physical and online resume profiles), by the referees you have noted, and by the educational institutions with whom we may undertake to verify your qualifications with, in accordance with our privacy policy and for recruitment purposes only.

For more information on how we process the information you have provided including relevant lawful bases (where relevant) please see our privacy policy which is available on our website ( https://www.madisonlogic.com/privacy/ ).