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
Similar Jobs
What We Do
Since 2005, Madison Logic has empowered the largest and fastest-growing companies to convert their best accounts faster by finding and engaging throughout the customer journey with the most influential members of the buying committee.
The ML Platform, a global multi-channel ABM media activation and measurement platform, enables marketers within enterprise organizations to leverage unique proprietary data to identify the accounts most likely to purchase, maximize engagement across multiple channels, and accelerate sales cycles to positively impact ROI.
Why Work With Us
How are we Unique:
Madison Logic solutions use the world’s leading B2B data and account intelligence to help you find, prioritize and engage global buying committees looking for solutions like yours.
Why work here:
Great work environment, supportive culture, opportunities for growth, and leaders who listen.
Gallery







