At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
Database Engineer Principal
Job ID
194971
Posted
14-Mar-2025
Service line
REI Segment
Role type
Full-time
Areas of Interest
Data & Analytics, Digital & Technology/Information Technology
Location(s)
Richardson - Texas - United States of America
What you’ll do
Plan, analyze, develop, maintain, and enhance complex data systems.
Participate in the design, specification, implementation, and maintenance of data systems.
Design, code, test, and document software programs of moderate to high complexity.
Design, develop, and maintain scalable data pipelines using Snowflake, dbt, Snaplogic, and other ETL tools.
Participate in design reviews and technical briefings.
Integrate data from various sources, ensuring consistency, accuracy, and reliability.
Develop and manage ETL/ELT processes to support data warehousing and analytics.
Assist in preparing requirement specifications, analyzing data, designing, and developing data-driven applications.
Resolve complex software development issues in production environments.
Utilize Python for data manipulation, automation, and integration tasks.
Assemble large, complex data sets to meet functional and non-functional business requirements.
Identify, design, and implement internal process improvements.
Build infrastructure for optimal data extraction, transformation, and loading.
Collaborate with cross-functional teams (Product, Data, Design, Frontend, Backend) to support data-related technical issues.
Write complex SQL queries, stored procedures, functions, and cursors in SQL Server and PostgreSQL.
Analyze long-running queries and develop performance optimization strategies.
Create and manage ETL processes using tools like SSIS or Informatica.
Perform DBA activities like system health maintenance, performance tuning, database access management, and deployment.
Utilize CI/CD tools for optimal productivity.
Collaborate with scrum teams in agile development methodologies.
Analyze, review, and alter programs to improve efficiency or adapt to new requirements.
Prepare documentation to describe program development, logic, coding, and corrections.
Collaborate with Data Scientists and analysts.
What you’ll do
Bachelor's degree in Information Systems, Mathematics, Computer Science, or a related field.
8+ years of relevant work experience in data engineering.
Expertise in data extraction, transformation, loading (ETL), data analysis, data profiling, and data governance.
Proficiency in relational and transactional databases, data warehousing, and data lakehouses for structured and unstructured data.
Strong experience in designing and developing enterprise-scale data warehouse systems using cloud-native and cloud-agnostic solutions (Snowflake, Azure Synapse, AWS Redshift, etc.).
Proven ability to design and develop reusable and scalable data products with data quality scores and integrity checks.
Experience in ingesting data from different formats and disparate systems including CRM and ERP systems such as Salesforce, PeopleSoft, SAP etc.
Deep understanding of data ingestion tools (Snap logic, ADF, Snow pipe, Matillion, etc.) to build end-to-end complex data workflows.
Experience with cloud platforms (AWS, Azure) and technologies, Agile methodologies, and DevOps principles.
Proficiency in architecting cloud-native solutions across multiple B2B and B2C data domains.
Experience in designing and developing modern APIs for secure data sharing across internal and external applications.
Strong expertise in designing and developing comprehensive relational and dimensional data models and ER diagrams (ERwin, SQL Workbench).
Experience with data orchestration tools (Apache Airflow, Chronos).
Proficiency in designing and developing data transformation models in dbt.
Ability to analyze statistical information, identify patterns, and design conceptual and logical data models.
Experience with CI/CD pipelines (Jenkins, Azure DevOps).
Knowledge of Python for data manipulation and automation.
Understanding of data governance frameworks and best practices.
Familiarity with source code versioning tools (GitHub).
Excellent written and verbal communication skills, strong organizational, problem-solving, and analytical skills.
Proficiency1 in working with RESTful APIs, including HTTP methods, endpoints, and request-response cycles.
Ability to conduct data validation and reconciliation to ensure accuracy and consistency.
Experience in validating data pipelines to meet business requirements and performance standards.
Why CBRE?
At CBRE, we believe we possess an encouraging environment where integrity, service, and excellence craft our approach to every opportunity. We are guided by the needs of the cities we inhabit, the communities we build and the world we live in.
CBRE named a Fortune’s Most Admired Real Estate Company Fourteen years in a row
CBRE agrees to acquire J&J Worldwide Services, a leading provider of engineering services, base support operations and facilities maintenance for the U.S. federal government.
Named a World’s Most Ethical Company by Ethisphere for 11th consecutive year.
Ranked #3 on Barron’s Most Sustainable Company list
Equal Employment Opportunity: CBRE is an equal opportunity employer that values diversity. We have a long-standing commitment to providing equal employment opportunity to all qualified applicants regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, pregnancy, age, citizenship, marital status, disability, veteran status, political belief, or any other basis protected by applicable law.
Candidate Accommodations: CBRE values the differences of all current and prospective employees and recognizes how every employee contributes to our company’s success. CBRE provides reasonable accommodations in job application procedures for individuals with disabilities. If you require assistance due to a disability in the application or recruitment process, please submit a request via email at recruitingaccommodations@cbre.com or via telephone at +1 866 225 3099 (U.S.) and +1 866 388 4346 (Canada).
NOTE: Some, but not all, of our positions may have an additional requirement to comply with COVID-19 health and safety protocols, including COVID-19 vaccination proof and/or rigorous testing. If you have questions about the requirement(s) for this position, please inform your Recruiter.
Investment Management
CBRE Investment Management is a leading global real assets investment management firm operating in over 30 offices and 20 countries around the world. Through its investor-operator culture, the firm seeks to deliver sustainable investment solutions across real assets categories, geographies, risk profiles and execution formats so that its clients, users, people and communities thrive.
Find out more (http://www.cbreim.com)
CBRE, Inc. is an Equal Opportunity and Affirmative Action Employer (Women/Minorities/Persons with Disabilities/US Veterans)