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                            Respect Customers. Respect Each Other.

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:

As a Sr. ETL Developer, you'll drive data integration solutions using Snowflake's cloud platform. Your role centers on extracting data from diverse sources, transforming it to align with business needs, and loading it into Snowflake for analysis. You'll write complex queries for applications and BI dashboards, optimize data retrieval and visualization processes. Working collaboratively with architecture and data teams, you'll play a crucial role in achieving business objectives through efficient data management and analysis.

• 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.

• University degree and 5+ years of practical experience OR 8+ 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

• 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.

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. Where applicable, hybrid WFH days work must be conducted from your home office located in a jurisdiction in which Madison Logic has the legal right to operate. WFH requires availability and responsiveness on a full-time basis from a distraction free environment with access to high-speed internet. Please inquire for more details.

Pay Transparency/Equity:

We are committed to paying our team equitably for their work, commensurate with their individual skills and experience.  Salary Range and additional compensation, including discretionary bonuses and incentive pay, are determined by a rigorous review process taking into account the experience, education, certifications and skills required for the specific role, equity with similarly situated team members, as well as employer-verified region-specific market data provided by an independent 3rd party partner.

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/).