Techstra Solutions LLC
Senior Data Modeler
Techstra Solutions LLC, Oak Brook, Illinois, United States, 60523
Techstra is seeking an experienced Senior Data Modeler. As a proficient modeler, you will lead data analysis efforts and perform data analysis tasks across various projects with a wide range of scope, intricate business needs, and technical requirements within a tightly coordinated multi-platform data environment. This role focuses on analysis and design, involving the creation and refinement of data solutions and models, which will subsequently be provided to developers, engineers, and DBAs for implementation.
From the day you join, you will hit the ground running surrounded by amazing people. Here is a look at some of the expectations and responsibilities for this position:
Responsibilities:
Ensure data accuracy, consistency, and quality by implementing data validation and cleansing processes.Identify and resolve data-related issues and errors, ensuring data integrity and availability.Maintain comprehensive documentation of data models, database schemas, and data flow processes.Collaborate with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand and address data requirements.Develop and maintain data models, including conceptual, logical, and physical models, to meet business requirements.Design and optimize data structures, tables, and schemas.Transform raw data into meaningful insights by creating views, stored procedures, and other data transformation mechanisms.Requirements:
Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures, or data modeling.7+ years experience in Utility domain knowledge required (outage, geodata, meters, etc).Experience with Erwin Data Intelligence, ERStudio or similar modeling tools, and required experience with Data Sourced from OMS, ADMS and CC&B desired.Hands-on experience with physical and relational data modeling.Experienced in design of Conceptual, Logical and Physical models to represent business concepts.Proficient in 3NF, Star Schema, Dimensional and Data Vault modeling techniques.In-depth knowledge of data warehousing, an understanding of database structures, design, theories and SCD (slowly changing dimensions) principles.Experience working with cloud-based environments (Azure) Storage and Database services.Expert knowledge of metadata management and related tools.Advanced troubleshooting skills.Prepare the Standard Operating Procedures with DB modelling.Strong SQL writing.Experience working with complex and potentially un-structured data sets JSON, XML, Parquet.Strong interpersonal skills.Excellent communication and presentation skills.Strong analytical and problem-solving skills.Location: This position is located in Oak Brook, Illinois.At Techstra Solutions, we help top companies and brands achieve the business value of Digital and Talent Transformation. We believe there are three components in successful business transformation: Business Strategy, Technology and Talent. It is the coming together of these three disciplines that enable companies to take full advantage of opportunities. It differentiates us. Our approach is holistic and all encompassing. We consider the full picture as we guide our clients on this journey.We are experts in transformation, business strategy, technology, innovation, and human capital management. We deliver our expertise through client consulting, innovative staffing solutions and software development. From strategy through implementation, we are dedicated to bringing our clients world-class business and talent solutions that fit strategic requirements and most importantly, deliver results.Equal Employment Opportunity Statement:Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.
#J-18808-Ljbffr
From the day you join, you will hit the ground running surrounded by amazing people. Here is a look at some of the expectations and responsibilities for this position:
Responsibilities:
Ensure data accuracy, consistency, and quality by implementing data validation and cleansing processes.Identify and resolve data-related issues and errors, ensuring data integrity and availability.Maintain comprehensive documentation of data models, database schemas, and data flow processes.Collaborate with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand and address data requirements.Develop and maintain data models, including conceptual, logical, and physical models, to meet business requirements.Design and optimize data structures, tables, and schemas.Transform raw data into meaningful insights by creating views, stored procedures, and other data transformation mechanisms.Requirements:
Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures, or data modeling.7+ years experience in Utility domain knowledge required (outage, geodata, meters, etc).Experience with Erwin Data Intelligence, ERStudio or similar modeling tools, and required experience with Data Sourced from OMS, ADMS and CC&B desired.Hands-on experience with physical and relational data modeling.Experienced in design of Conceptual, Logical and Physical models to represent business concepts.Proficient in 3NF, Star Schema, Dimensional and Data Vault modeling techniques.In-depth knowledge of data warehousing, an understanding of database structures, design, theories and SCD (slowly changing dimensions) principles.Experience working with cloud-based environments (Azure) Storage and Database services.Expert knowledge of metadata management and related tools.Advanced troubleshooting skills.Prepare the Standard Operating Procedures with DB modelling.Strong SQL writing.Experience working with complex and potentially un-structured data sets JSON, XML, Parquet.Strong interpersonal skills.Excellent communication and presentation skills.Strong analytical and problem-solving skills.Location: This position is located in Oak Brook, Illinois.At Techstra Solutions, we help top companies and brands achieve the business value of Digital and Talent Transformation. We believe there are three components in successful business transformation: Business Strategy, Technology and Talent. It is the coming together of these three disciplines that enable companies to take full advantage of opportunities. It differentiates us. Our approach is holistic and all encompassing. We consider the full picture as we guide our clients on this journey.We are experts in transformation, business strategy, technology, innovation, and human capital management. We deliver our expertise through client consulting, innovative staffing solutions and software development. From strategy through implementation, we are dedicated to bringing our clients world-class business and talent solutions that fit strategic requirements and most importantly, deliver results.Equal Employment Opportunity Statement:Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.
#J-18808-Ljbffr