Current Job Openings

Data Modeler, Sara Software LLC, Olathe, KS

 

Duties: Build complex software models that extract data from multiple source systems before being transformed and populated into the data warehouse. Perform data modeling for real time transactional and data warehouse systems. Deliver dashboards and reports using data visualization techniques. Create scripts to develop/update complex stored procedures, views, and DML in SQL.  Create entity relationship diagrams to detail the relationships between various entities. Design and Develop conceptual, logical and physical entity-relationship models. Create business information modeling for large, complex projects and ensure that project information conforms to corporate information architecture standards. Create mapping documents that include tables, files– from source to target. Design and develop data warehouse modules using IBM Data Stage; integration of new modules with existing modules. Successfully manage operations on Datastage Enterprise Data Warehouse (EDW) including creation, designing, development, implementation, and testing.  Create reverse and forward engineering relational databases models for MS SQL Server, Oracle. Work on Requirements Gathering and Management. Prepare documentation for technical resources and business workflows for easy and better understanding of process flow by senior management and end users. Pair up with other teams to help trouble shoot data issues in a production environment and come up with plan to resolve as quickly as possible. Collaborate with Data Architects, ETL developers, Business Analysts, Report Developers, DBAs, and business stakeholders to deliver scalable, efficient, and fault tolerant solutions.

 

Requirements: Master’s degree in Information System Technologies, Computer Science, Computer Engineering, or a related field, plus at least three years of related experience. Alternatively, the employer will accept a Bachelor’s degree in Information System Technologies, Computer Science, Computer Engineering, or a related field, plus at least five years of related experience. Requires three years combined experience with one or more technologies in each of the following categories: Data analysis, data manipulation and mapping, data transformation and interpretation, and modelling, including multiple regression techniques; Knowledge of Relational Database Systems (RDBMS): DB2/Oracle/MS SQL Server/Netezza/Teradata; Documenting BRD’s, FRD’s and TDD’s; and Working with a data visualization tool: Power BI/Tableau. Also requires two years of combined experience working in each of the following methodologies: Agile Methodology (Jira, creating work orders, deliverables, Data Change Requests (DCRs), release packages, release configuration items (RELCIs), work logs, and doing deployments); and Software Versioning & Revision Control systems: (Apache Subversion (SVN)). Related experience must include: Using data warehousing concepts with regards to architecture design, metadata discovery, dimensional modeling, implementation of EDW logical and physical models, and other maintenance activities; Performance tuning and writing complex SQL queries, PL/SQL procedures and functions; Determining enterprise data needs and data strategy, including the development of data policies and standards; Data cleansing, data quality and accuracy for critical data elements used publicly; and working with the software development life cycle (SDLC) and developing complex IT projects in agile environment. Local travel may be required as needed to visit client sites.


Apply to : sss.jobs@sarasoftwaresystems.com

Join companies around the world that work with us to run marketing campaigns that deliver results for their business