Job Location: Chicago, IL
Data Modeling Analyst – INF001809
This versatile role seeks seasoned data professionals who can design and implement our data solutions for relational and modern data architecture. As a data modeler analyst, you will work closely with data architects, analysts, scientists, and developers to implement data modeling solutions. The fundamental expectation of this role is to analyze and translate business needs into long-term solution data models. In addition, this role will participate in process improvement initiatives and set the best practice standards around Data modeling, Metadata, Data Governance, and Master Data Management.
Location Note
This role can be performed remotely in a work from home arrangement within the continental United States. There is an expectation the role may need to come to a business office, typically Chicago, as many as 6 times a year, with typically two weeks’ notice for various department meetings.
Essential Functions
- Development of the conceptual, logical, and physical data models for implementing RDBMS, data marts, and data lakes on target platforms (SQL/NoSQL).
- Evaluating implemented data systems for variances, discrepancies, and efficiency.
- Create logical data models via virtualization
- Analyzing and translating business needs into long-term solution data models
- Source to target mappings and ETL design review
- Participate in maintenance and enhancements of modeling quality standards such as mappings and technical specs.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
- Review modifications of existing systems for cross-compatibility.
- Update and optimize local and metadata models.
- Consult in troubleshooting and optimizing data systems.
Required Experience
- Bachelor’s degree in Math, Computer Science, Information Technology, Electrical or Computer Engineering or related field or equivalent work experience (including military) required.
- 3+ years of strong SQL experience
- Hands-on relational, dimensional, or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
- Experience in Data Modeling at an enterprise level with hands-on conceptual, logical, and physical model development
- Experience in ETL/Data warehousing Solutions (Talend, Informatica)
- Experience working with one or more enterprise data modeling tools, such as ER/Studio, Erwin, or others.
- Good understanding of Database architectures
- Hands-on experience with data warehouse, data lake, and enterprise big data platforms in multi-data center contexts required
Preferred Qualifications
- Knowledge of Hadoop ecosystem and different frameworks inside it- HDFS, YARN, MapReduce, Apache Pig, Hive, Flume, Sqoop, ZooKeeper, Oozie, Impala and Kafka
- Knowledge of ETL best practices, Cl/CD Pipeline, monitoring & alert would be a plus point
- Experience in data virtualization using Denodo
- Experience in data quality processes like data profiling, cleansing
- Experience with analytics tools like Cognos, Tableau
- Knowledge of different Operating System – UNIX, Linux, Solaris, or MS Windows
- Real-time processing Framework (Apache Spark)
- Programming Languages: Python/R/Java
- Experience working with analytics teams and solving business problems
- Strong attention to detail
- Hands on experience with communication tools like PowerPoint, Visio, JIRA etc.
Job
: Information Technology
Location(s)
: Illinois-CHICAGO_IL Oklahoma-TULSA_OK, Wisconsin-MADISON_WI, Washington-RICHLAND_WA, Iowa-URBANDALE_IA, Tennessee-KNOXVILLE_TN, Washington-LONGVIEW_WA, Illinois-SCHAUMBURG_IL, Missouri-COLUMBIA_MO, North Carolina-GREENVILLE_NC, Iowa-MARION_IA, Oregon-MEDFORD_OR, Virginia-ROANOKE_VA, West Virginia-MORGANTOWN_WV, North Carolina-WILMINGTON_NC, New Hampshire-BEDFORD_NH, Wisconsin-BROOKFIELD_WI, Maine-SOUTH PORTLAND_ME
U.S. Cellular® is an EEO employer and gives consideration to qualified applicants without regard to race/color/age/religion/sex/sexual orientation/gender identity/national origin/disability/veteran status, pregnancy or genetic information.
Submit CV To All Data Science Job Consultants Across United States For Free

