Company Overview
Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance-based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.
Our seasoned professionals deliver services based on Milestone's best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 3,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed.
Job Overview
Position Overview:
We are currently seeking a skilled Data Architect with data modeling experience to join the Data Engineering team. The ideal candidate will have a strong foundation in data architecture, with a keen ability to design, implement, and manage data models that support our organization's needs. This role involves collaborating with data scientists, analysts, and IT team members to ensure our data structures are optimized for efficiency, scalability, and reliability.
Key Responsibilities
- Develop and maintain conceptual, logical, and physical data models that align with business objectives and data governance standards.
- Design and implement data models that effectively support business processes and decision-making.
- Collaborate with stakeholders to understand business requirements and translate them into data models.
- Optimize data architectures for both operational and analytical purposes to improve performance and scalability.
- Deliver working solutions including data pipelines, worksheets, snowflake environments, Snow SQL, and Python automation code as required as an individual contributor while also providing leadership and best practices to other team members following your design and development best practices.
- Provide solid data modeling and architecture best practices for modern data warehousing solutions, including leveraging traditional Kimball/Inmon best practices where necessary along with Data Vault and similar approaches where possible.
- Ensure data integrity and quality by developing and implementing data governance and validation processes.
- Stay abreast of industry trends and advancements in data modeling techniques and technologies, recommending improvements to our practices as appropriate.
- Work closely with data engineers and IT personnel to implement and refine data models within our data warehousing and business intelligence environments.
- Provide technical guidance and support to team members on best practices in data modeling and data architecture.
- Must be proficient in Oracle and SQL coding (with recent experience) Minimum of 5 years.
- Must be proficient in OLTP/3NF (Online transaction processing, 3rd normal form) as well as dimensional/data mart modeling (star schema, snowflake) Minimum of 5 years.
- Must be proficient in data analysis and SQL skills Minimum of 5 years.
- Experience with SDLC / Scaled agile delivery frameworks for data warehouse projects minimum of 5 years.
- Experiences in Data modeling in Snowflake Database, Oracle Database, and in Salesforce
- Experience in Snowflake database profiling, creating, advising and reviewing data models for our data warehouse as well as data mart areas.
- Should be able to provide design of the table structures with proper data analysis and mapping capabilities.
- Will be responsible for changing, maintaining the data models and be able to work closely with the business team to understand the requirements and provide guidance on the design to the development team.
- Maintain documentation of data models, data dictionaries, and related metadata to ensure clarity and consistency across the organization.
- Should be able to assist both developers and testers to ensure that data processing is accurate, efficient, and complete.
- Should be able to prioritize work activities to meet the timelines.
Qualifications
- Bachelor's degree in computer science, Information Technology, Data Science, or a related field.
- Proven experience as a Data Modeler or in a similar role, with a strong portfolio of data architecture and modeling projects.
- Proficient in data modeling tools and technologies, with a deep understanding of relational and non-relational database systems.
- Strong analytical skills with the ability to solve complex problems and translate business requirements into technical solutions.
- Excellent communication and collaboration skills, with the ability to work effectively with both technical and non-technical stakeholders.
- Familiarity with data governance, data quality management, and data security practices.
- Knowledge of SQL, NoSQL, ETL processes, and business intelligence platforms.
Compensation
Estimated Pay Range: Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location.
Our Commitment to Diversity & Inclusion
At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for ouremployees butis also critical to our continued success.
Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees.
We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you.
This position may be assigned to a client that requires all individuals on-site to have the COVID-19 vaccination. The individual must be fully vaccinated before starting work at such a client site.
