Data Architect - Modeler
Columbus
BJSS
BJSS, the tech consultancy that makes the difference when you need better outcomes from software and technology.About Us
We’re an award-winning innovative tech consultancy - a team of creative problem solvers. Since 1993 we’ve been finding better, more sustainable ways to solve complex technology problems for some of the world’s leading organizations and delivered solutions that millions of people use every day.
In the last 30 years we won several awards, including our most recent inclusion in the Forbes World's Best Management Consulting Firms report.
Operating from 26 locations across the world, we bring together teams of creative experts with diverse backgrounds and experiences, who enjoy working and learning in our collaborative and open culture and are committed to world-class delivery.
We have an established presence in the United States for over ten years. With offices in New York City, Columbus, Ohio and Houston, Texas we offer a local touch with a global reach.
We want to continue to grow and need people just like you!
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture AWS Azure Big Data Business Intelligence Consulting Data analysis Data governance Data pipelines Data quality Data Warehousing Engineering ETL GCP Hadoop Machine Learning MySQL NoSQL Oracle Pipelines Power BI Security Spark SQL Tableau
Perks/benefits: 401(k) matching Career development Competitive pay Health care Unlimited paid time off
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Research Scientist jobs
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open BI Analyst jobs
- Open Sr Data Engineer jobs
- Open Business Intelligence Engineer jobs
- Open Lead Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Data Science Intern jobs
- Open Senior Business Intelligence Analyst jobs
- Open Junior Data Scientist jobs
- Open Software Engineer, Machine Learning jobs
- Open Azure Data Engineer jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Analytics Engineer jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Analyst II jobs
- Open Data Engineering Manager jobs
- Open ETL Developer jobs
- Open Data management-related jobs
- Open Tableau-related jobs
- Open Data quality-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open Data visualization-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Deep Learning-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Git-related jobs
- Open Docker-related jobs