PDS Tech Inc Data Analytics and Development in Fort Worth, Texas
PDS Tech Inc. is seeking a Data Analytics and Development Specialist, in Fort Worth, TX.
The successful candidate will contribute to development and enhancement of the Common Capacity Model (CCM) Database.
The candidate will develop user interface reports/forms to allow Capacity and Rate Readiness (CRR) modelers to quickly identify and cleanse erroneous data from the database.
The user interface will also allow Supply Chain Management (SCM) buyers to upload sourcing data and generate canned reports from the CCM to help guide sourcing decisions.
The baseline CCM is complete, but additional step improvements need to be made to incorporate other types of manufacturing into the data set.
The candidate will assist the CCM architect in streamlining the SQL queries, VBA coding and development of diagnostic reports to alert the capacity database administrator when problems arise.
Additional tasks is to connect SCM’s sourcing tools into the CCM to automate data entry.
Specific duties include:
Use of SQL and VBA to develop, test and deploy CCM capabilities.
Further refinement of standard excel templates including VBA macros for CRR team analysis of suppliers’ survey data.
Generate standard report and user interface forms to allow non-technical users to utilize CCM for capacity reporting and sourcing decisions.
Assist in data system integration with SCM sourcing tools.
Troubleshoot existing CCM model as required.
Bachelor's degree and 6 - 10 years or master's degree 4 - 6 years
US Person/US Citizen
Areas of Expertise = Database Design
Software Skills = MS Access Advanced, MS Excel Advanced, SQL.
Technical Skills = Data Cleansing Techniques, User Interface Design, VBA.
All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or other legally protected status.