Database Warehouse Analyst
VA-Remote, United States
Taylor Corporation
Let Us Power Your Potential
Taylor Corporation is a dynamic, diversified company with big plans for the future ― and your career. We power our employees’ potential and strive to create opportunity and security for every member of the team. If you’re ready for something bigger ― more challenge, more variety, more pathways for professional growth ― we should talk. We’re passionate about our work, we believe there is always a better way, and we’re looking for people like you.
Ready to reach your potential? It’s time to look at Taylor.
Your Opportunity: MGI is the largest association-focused direct marketing agency in North America, specializing in helping membership organizations grow through strategic consulting, marketing, and data-driven solutions. With over 45 years of experience, MGI partners with clients to increase membership and revenue while providing expert guidance in marketing and research.
The Database Warehouse Analyst plays a vital role in designing, developing, and maintaining Taylor Corporation’s data warehouse systems and related data marts using SQL Server and Microsoft Fabric. This position requires a strong technical foundation in database architecture, metadata creation, and data repository management to ensure the availability and integrity of data for business intelligence needs. Acting as a bridge between Data Analytics and business units, you will help identify information requirements, troubleshoot operational issues, and generate insights that drive informed decision-making, particularly in marketing. Some background in Marketing Analytics or business analytics is highly important to enable the candidate to work closely with Marketing Managers and clients, understand their business needs and problems and be able to design and execute solutions using data architecture, warehousing and analytics. Strong communication skills and ability to clearly translate complex technical concepts for non-technical stakeholders are essential.
Your Responsibilities:
- Design, implement, and manage database architecture, metadata, and data repositories to support data warehouse and related data mart environments within SQL Server and Microsoft Fabric.
- Automate and improve existing manual or partially automated SQL processes as well as create new automated processes for new clients and projects in the MS SQL and MS Fabric environments.
- Maintain and document the architecture, data flows, business rules and processes of the data warehouse environment.
- Perform data mining and analytics to deliver business insights.
- Collaborate closely with business units to determine specific business needs, translating them into technical specifications and framing technical solutions to business problems.
- Create dashboards, visualizations and reports for marketing analytics
- Ensure data accuracy, integrity, and reliability in all warehouse and reporting processes. Be able to troubleshoot and resolve issues.
You Must Have:
- 4+ years of related experience
- Proficiency in SQL Server, including advanced SQL for complex querying, data extraction, and transformation
- Familiarity with Microsoft Fabric for data management, analysis, and reporting
- Demonstrated expertise in ETL processes, data modeling, and data integration
- Experience solving business problems using analytics as well as experience framing technical solutions based on business rules provided by non-technical team members, creating technical SOW’s and project plans
- Experience with business intelligence tools, such as Tableau, Power BI or SSRS, for reporting and visualization
- Solid analytical and problem-solving skills with a detail-oriented approach
- Excellent communication skills to effectively collaborate with IT and business teams, translating technical language into business context
We Would Also Prefer:
- Familiarity with programming languages, such as Python or R, to support data analysis, predictive analytics, and automation tasks
- Knowledge of Agile or Scrum methodologies for efficient project management
- Experience cleansing and formatting large data files to prep them for processing and analytics in the SQL Server/MS Fabric environments
- Experience working with professional associations and certifying bodies in an IT or data analytics related role
- Creative approach to problem solving
- Strong strategic thinking as it relates to optimizing and improving marketing tactics using data strategy
About Taylor Corporation
One of the largest graphics communications firms in North America, Taylor’s family of companies provide a diverse set of products, services, and technologies addressing the toughest communication challenges. For nearly 50 years, Taylor has been a premier provider of powerful and innovative products, services, and expertise for individuals, businesses, and distributors large and small. Our 10,000+ employees spanning 26 states and seven countries work diligently to create the interactive, printing, and marketing solutions that have helped build some of the world’s more recognizable brands. Everything we do begins with identifying the unique priorities and needs of our customers and creating one-of-a-kind solutions. We offer a comprehensive benefit package including several health plans to choose from, dental, vision, wellness programs, life and disability coverage, flexible spending accounts, health savings accounts, 401(k) plan with company match, paid time off (PTO) and 64 hours of annual holiday pay.
The Employer retains the right to change or assign other duties to this position.
Taylor Corporation is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
Taylor Corporation including all partners and affiliates is an Equal Opportunity Employer/Veterans/Disabled.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Business Analytics Business Intelligence Consulting Data analysis Data Analytics Data management Data Mining Data strategy Data warehouse ETL MS SQL Power BI Python R Research Scrum Security SQL Tableau
Perks/benefits: 401(k) matching Career development Flex hours Flex vacation Health care Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.