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.

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:

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.