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 industryExtensive experience in data modeling, with a focus on analytics solutionsProficient in data modeling tools such as ER / Studio, ERwin, PowerDesigner or similarStrong understanding of database management systems, including SQL Server, Oracle, MySQL and NoSQL databasesExperience with data warehousing concepts, ETL processes and data integrationExcellent analytical and problem-solving skills with a keen attention to detailStrong communication and interpersonal skills to effectively collaborate with stakeholdersAbility to work independently and manage multiple projects simultaneouslyKnowledge of big data technologies (e.g., Hadoop, Spark) and cloud platforms (e.g., AWS, Azure, GCP) is a plusFamiliarity with business intelligence tools such as Tableau, Power BI or similarKnowledge of data governance and data security best practicesExperience with machine learning and predictive analytics modelsSome of the Perks
20 days paid vacation per year and 12 BJSS holidays5 paid sick daysCompetitive medical, dental and vision plans employer funded 80%4 x salary Life and AD&DCommuter benefits401K plan (BJSS will contribute 3% of salary into your 401K)An industry-leading referral scheme, with no limits on the number of referralsOur 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 WFHTraining opportunities and incentives – we support professional certifications across engineering and non-engineering roles, including unlimited access to O’ReillyYou will become part of a squad with people from different areas within the business who will help you grow at BJSSA collaborative and inspiring environment working alongside some of the best tech people in the industryWe partner with Lifeworks to offer wellbeing support to our employeesWorking 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.