Data Architect - Modeler

About the Role

As a Senior Data Architect Modeler, you will play a critical role in designing, developing and implementing conceptual and physical data models to support our analytics solutions. You will work closely with data architects, analysts and other stakeholders to ensure our data models meet business requirements and enhance our clients' decision-making capabilities.

Key Responsibilities:

• Design and develop conceptual, logical and physical data models to support analytics solutions
• Collaborate with data architects, data engineers and business analysts to gather requirements and define data modeling standards
• Implement data modeling best practices to ensure high performance, scalability and maintainability
• Create and maintain data dictionaries, metadata repositories and documentation for data models
• Optimize and refine existing data models to improve data quality and performance
• Conduct data analysis and profiling to ensure data integrity and accuracy
• Work with ETL developers to integrate data models into data pipelines and workflows
• Collaborate with stakeholders to understand business needs and translate them into effective data models
• Stay updated with the latest industry trends and technologies in data modeling and analytics
• Mentor and provide guidance to junior data modelers and other team members

This role will be mainly based in Columbus, Ohio.

About You

You’ll bring extensive data architecture experience gained through a combination of industry and consulting roles. You will be comfortable developing and strengthening peer-to-peer level relationships at all levels with our clients.

Ideally, you will have as much of the following experience as possible:

• Experience in the digital consultancy industry
• Extensive experience in data modeling, with a focus on analytics solutions
• Proficient in data modeling tools such as ER/Studio, ERwin, PowerDesigner or similar
• Strong understanding of database management systems, including SQL Server, Oracle, MySQL and NoSQL databases
• Experience with data warehousing concepts, ETL processes and data integration
• Excellent analytical and problem-solving skills with a keen attention to detail
• Strong communication and interpersonal skills to effectively collaborate with stakeholders
• Ability to work independently and manage multiple projects simultaneously
• Knowledge of big data technologies (e.g., Hadoop, Spark) and cloud platforms (e.g., AWS, Azure, GCP) is a plus
• Familiarity with business intelligence tools such as Tableau, Power BI or similar
• Knowledge of data governance and data security best practices
• Experience with machine learning and predictive analytics models

Some of the Perks

• 20 days paid vacation per year and 12 BJSS holidays
• 5 paid sick days
• Competitive medical, dental and vision plans employer funded 80%
• 4 x salary Life and AD&D
• Commuter benefits
• 401K plan (BJSS will contribute 3% of salary into your 401K)
• An industry-leading referral scheme, with no limits on the number of referrals
• Our roles are not fully remote as we take pride in the tight knit communities we have created at our local offices. But we offer plenty of flexibility and you can split your time between the office, client site and WFH
• Training opportunities and incentives – we support professional certifications across engineering and non-engineering roles, including unlimited access to O’Reilly
• You will become part of a squad with people from different areas within the business who will help you grow at BJSS
• A collaborative and inspiring environment working alongside some of the best tech people in the industry
• We partner with Lifeworks to offer wellbeing support to our employees

Working Restrictions

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

BJSS will only employ those who are legally authorized to work in the United States for this opening. We are unable to offer visa sponsorship.