FAMCe is solidly focused on providing a working environment that offers our employees career growth opportunities and a full benefits package. We have a comprehensive training and safety program as well as other educational and development opportunities for those interested. We respect work life balance and appreciate a hard work ethic.
Health Care Benefits
Insperity Discount Program
Employee Assistance Program
Job: Sr. Database Administrator/Analyst
Job Location: MORRIS, IL, USA
Design, model, and implement corporate data warehousing activities in ERP system;
Develop ETL solutions to migrate data, test data transformations and validate data
for target and source systems, build packages in SSIS;
Administer, test, and implement updated databases to ensure operation, sales
efficiency and security;
Collaborate with logistic analyst and sales manager to present reports by querying
data repositories and generate periodic reports using Business Intelligence and Data
Configure computer system to ensure smooth operation of the database and ERP
Perform data scrubbing, identify missing or erroneous values and outliers by using
batch processing, statistical techniques, and data manipulation packages;
Monitor and review data processing regarding supply chain and logistics procedures,
identify problems and propose improvement plans;
Develop and apply statistical models to monitor reusable market development and
o Implement data mining and data engineering on domestic and export markets
analysis reports and business plans;
o Optimize prediction models using internal and external data to depict trends at
the company level and industrial level;
o Create pricing models targeting customers, manufacturers and end users of
electronics and related products;
Perform data mining and machine learning techniques on customer and product
classification, IT asset management, reverse logistics, data erasure, risk
Hold training sessions with employees and management team about data security,
statistics model use and ETL system design, and edit internal training materials;
Develop standards and guidelines for data input and output of the report system;
Work with departmental directors to perform specific data analysis as requested;
Required Travel: None
Required License: None
Required Education: Master Degree in Computer Science, Informatics or closely related field
Required Employment Experience:
Proficiency in ETL process, developing ETL solutions, building ETL packages,
troubleshooting ETL workflows, tuning performance.
Proficiency in relational and dimensional data modeling / ER diagrams.
Proficiency in database management techniques, including designing and tuning
complex queries using SQL and T-SQL.
Demonstrated strong data analysis skills using business intelligence and data analysis
software including Tableau, Power BI, Python libraries (Matplotlib, Plotly, Seaborn) and
Demonstrated ability developing machine learning models to work on regression and
classification predictions using Python;
Demonstrated data mining ability, including detecting outliers, applying unsupervised
machine learning techniques using Python;
Proficiency in system data backup, recovery and security.
Demonstrated strong knowledge of enterprise-wide computing architectures and
infrastructure practices spanning multiple operations systems and hardware platforms.
Demonstrated ability to work and communicate effectively in English in a team
environment as well as interface with all levels of staff/management within the
Annual salary at $98,000 for qualified applicants. Send over resume to email@example.com
AN EQUAL OPPORTUNITY EMPLOYER.
“Working here at First America Metal Electronics for almost 4 years has been a great career choice for me. I started here as the receptionist and am now the Logistics Coordinator. I work with and have met some amazing people and been given many opportunities to learn and grow. FAMCe is a wonderful place to come to work everyday.”
“For me FAMCe prides itself as a Family and Multi-talented Community and I’ve been here almost 3 years. Working here has given opportunity for learning different materials and departments. I would say we are a great team that works together with trust, respect and motivation. ”